[ROOT] dt DimCustomer < WHERE DimGeographyId EQ '220' >
57 items
| DimCustomerId | AddressLine1 | AlternateKey | BirthDate | CommuteDistance | DateFirstPurchase | DimGeographyId | EmailAddress | EnglishEducation | EnglishOccupation | FirstName | FrenchEducation | FrenchOccupation | Gender | HouseOwnerFlag | LastName | MaritalStatus | MiddleName | NameStyle | NumberCarsOwned | NumberChildrenAtHome | Phone | SpanishEducation | SpanishOccupation | TotalChildren | YearlyIncome |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20802 | 191, rue de Cambrai | AW00020802 | 1972-11-26 | 0-1 Miles | 2013-06-10 | 220 | jon22@adventure-works.com | Partial College | Manual | Jon | Baccalauréat | Ouvrier | M | 1 | Li | S | 0 | 0 | 0 | 1 (11) 500 555-0125 | Estudios universitarios (en curso) | Obrero | 2 | 10000 | |
| 25456 | 118, rue Faubourg St Antoine | AW00025456 | 1981-10-24 | 0-1 Miles | 2014-01-11 | 220 | kelvin40@adventure-works.com | Partial High School | Manual | Kelvin | Niveau bac | Ouvrier | M | 1 | Cai | M | A | 0 | 2 | 4 | 1 (11) 500 555-0112 | Educación secundaria (en curso) | Obrero | 5 | 10000 |
| 20858 | 8734, rue Villedo | AW00020858 | 1985-01-31 | 0-1 Miles | 2013-08-30 | 220 | damien17@adventure-works.com | Bachelors | Clerical | Damien | Bac + 4 | Employé | M | 1 | Stone | M | 0 | 0 | 0 | 1 (11) 500 555-0150 | Licenciatura | Administrativo | 0 | 30000 | |
| 25484 | 39, route de Marseille | AW00025484 | 1986-09-13 | 0-1 Miles | 2013-12-05 | 220 | bailey40@adventure-works.com | Partial College | Clerical | Bailey | Baccalauréat | Employé | F | 1 | Wright | M | L | 0 | 0 | 2 | 1 (11) 500 555-0118 | Estudios universitarios (en curso) | Administrativo | 2 | 30000 |
| 20884 | 1211, rue des Ecoles | AW00020884 | 1982-10-11 | 1-2 Miles | 2013-11-08 | 220 | darren43@adventure-works.com | Bachelors | Clerical | Darren | Bac + 4 | Employé | M | 0 | Schmidt | S | 0 | 0 | 1 | 1 (11) 500 555-0180 | Licenciatura | Administrativo | 1 | 30000 | |
| 25806 | 6614, rue Surcouf | AW00025806 | 1969-08-05 | 10+ Miles | 2013-08-31 | 220 | dwayne12@adventure-works.com | Partial High School | Skilled Manual | Dwayne | Niveau bac | Technicien | M | 1 | Dominguez | S | L | 0 | 3 | 1 | 1 (11) 500 555-0142 | Educación secundaria (en curso) | Obrero especializado | 5 | 70000 |
| 21538 | 52, rue Henri Gagnon | AW00021538 | 1966-01-10 | 5-10 Miles | 2013-12-20 | 220 | tara6@adventure-works.com | High School | Management | Tara | Bac + 2 | Direction | F | 1 | Luo | M | W | 0 | 2 | 2 | 1 (11) 500 555-0181 | Educación secundaria | Gestión | 5 | 80000 |
| 26368 | 33, place de la République | AW00026368 | 1981-06-06 | 0-1 Miles | 2013-10-09 | 220 | bharat0@adventure-works.com | Partial High School | Manual | Bharat | Niveau bac | Ouvrier | M | 1 | Mirchandani | S | 0 | 2 | 3 | 1 (11) 500 555-0113 | Educación secundaria (en curso) | Obrero | 4 | 10000 | |
| 21542 | 7, place de Brazaville | AW00021542 | 1965-02-23 | 5-10 Miles | 2013-12-08 | 220 | patricia9@adventure-works.com | Partial High School | Skilled Manual | Patricia | Niveau bac | Technicien | F | 0 | Vance | M | L | 0 | 3 | 1 | 1 (11) 500 555-0158 | Educación secundaria (en curso) | Obrero especializado | 5 | 70000 |
| 26909 | 2705, rue des Bouchers | AW00026909 | 1977-08-23 | 0-1 Miles | 2013-03-01 | 220 | christine13@adventure-works.com | Bachelors | Clerical | Christine | Bac + 4 | Employé | F | 1 | Nath | S | M | 0 | 0 | 0 | 1 (11) 500 555-0150 | Licenciatura | Administrativo | 1 | 20000 |
| 21677 | 311, rue Villedo | AW00021677 | 1987-08-27 | 1-2 Miles | 2013-10-29 | 220 | cedric34@adventure-works.com | Partial High School | Manual | Cedric | Niveau bac | Ouvrier | M | 0 | Chander | S | H | 0 | 2 | 0 | 1 (11) 500 555-0112 | Educación secundaria (en curso) | Obrero | 0 | 20000 |
| 26945 | 33, allée des Princes | AW00026945 | 1986-04-14 | 0-1 Miles | 2013-05-30 | 220 | katelyn36@adventure-works.com | Partial College | Manual | Katelyn | Baccalauréat | Ouvrier | F | 0 | Hill | S | 0 | 1 | 0 | 1 (11) 500 555-0160 | Estudios universitarios (en curso) | Obrero | 0 | 20000 | |
| 22322 | 67, avenue de l´ Union Centrale | AW00022322 | 1987-08-17 | 2-5 Miles | 2013-05-03 | 220 | roger15@adventure-works.com | High School | Manual | Roger | Bac + 2 | Ouvrier | M | 1 | Zhao | S | 0 | 1 | 0 | 1 (11) 500 555-0114 | Educación secundaria | Obrero | 0 | 30000 | |
| 27849 | 3738, chaussée de Tournai | AW00027849 | 1976-08-03 | 0-1 Miles | 2013-11-07 | 220 | dalton31@adventure-works.com | Bachelors | Clerical | Dalton | Bac + 4 | Employé | M | 1 | Adams | M | 0 | 0 | 0 | 1 (11) 500 555-0111 | Licenciatura | Administrativo | 1 | 20000 | |
| 22392 | 505, quai Paul Doumer | AW00022392 | 1975-08-13 | 0-1 Miles | 2013-06-05 | 220 | bailey4@adventure-works.com | Partial College | Manual | Bailey | Baccalauréat | Ouvrier | F | 1 | Gray | M | A | 0 | 1 | 0 | 1 (11) 500 555-0130 | Estudios universitarios (en curso) | Obrero | 2 | 10000 |
| 27895 | 876, rue de Berri | AW00027895 | 1973-12-07 | 0-1 Miles | 2013-12-15 | 220 | colin35@adventure-works.com | Partial College | Manual | Colin | Baccalauréat | Ouvrier | M | 0 | Pal | S | 0 | 1 | 0 | 1 (11) 500 555-0131 | Estudios universitarios (en curso) | Obrero | 2 | 20000 | |
| 22498 | 68, avenue de l´ Union Centrale | AW00022498 | 1979-07-30 | 0-1 Miles | 2013-08-11 | 220 | pedro26@adventure-works.com | High School | Manual | Pedro | Bac + 2 | Ouvrier | M | 0 | Jimenez | S | S | 0 | 2 | 3 | 1 (11) 500 555-0114 | Educación secundaria | Obrero | 3 | 20000 |
| 28457 | 703, boulevard du Montparnasse | AW00028457 | 1951-07-03 | 0-1 Miles | 2013-12-31 | 220 | bruce18@adventure-works.com | Graduate Degree | Clerical | Bruce | Bac + 3 | Employé | M | 0 | Gonzalez | S | 0 | 0 | 0 | 1 (11) 500 555-0179 | Estudios de postgrado | Administrativo | 1 | 10000 | |
| 22658 | 30, allée des Princes | AW00022658 | 1980-08-19 | 0-1 Miles | 2013-11-06 | 220 | devin19@adventure-works.com | High School | Manual | Devin | Bac + 2 | Ouvrier | M | 1 | Rodriguez | S | 0 | 2 | 2 | 1 (11) 500 555-0149 | Educación secundaria | Obrero | 2 | 20000 | |
| 28546 | 38, route de Marseille | AW00028546 | 1996-05-28 | 1-2 Miles | 2013-06-29 | 220 | alisha12@adventure-works.com | Partial High School | Manual | Alisha | Niveau bac | Ouvrier | F | 1 | Xu | M | 0 | 2 | 0 | 1 (11) 500 555-0173 | Educación secundaria (en curso) | Obrero | 0 | 20000 | |
| 22681 | 1208, rue Maillard | AW00022681 | 1979-08-22 | 0-1 Miles | 2013-06-10 | 220 | tristan3@adventure-works.com | Partial College | Clerical | Tristan | Baccalauréat | Employé | M | 1 | Barnes | S | T | 0 | 2 | 2 | 1 (11) 500 555-0126 | Estudios universitarios (en curso) | Administrativo | 2 | 30000 |
| 28739 | 24, rue Philibert-Delorme | AW00028739 | 1988-12-22 | 1-2 Miles | 2012-06-16 | 220 | mya10@adventure-works.com | High School | Manual | Mya | Bac + 2 | Ouvrier | F | 0 | Perry | S | 0 | 1 | 0 | 1 (11) 500 555-0117 | Educación secundaria | Obrero | 0 | 30000 | |
| 23927 | 212, rue Marbeuf | AW00023927 | 1980-02-12 | 0-1 Miles | 2013-08-17 | 220 | seth47@adventure-works.com | Partial College | Clerical | Seth | Baccalauréat | Employé | M | 1 | Collins | S | 0 | 2 | 2 | 1 (11) 500 555-0185 | Estudios universitarios (en curso) | Administrativo | 2 | 30000 | |
| 29361 | 33, rue Georges-Clémenceau | AW00029361 | 1983-03-05 | 2-5 Miles | 2012-07-07 | 220 | sheena15@adventure-works.com | Partial College | Manual | Sheena | Baccalauréat | Ouvrier | F | 0 | Nara | S | 0 | 1 | 1 | 1 (11) 500 555-0114 | Estudios universitarios (en curso) | Obrero | 1 | 20000 | |
| 23936 | 2, rue Lafayette | AW00023936 | 1994-11-18 | 0-1 Miles | 2013-06-01 | 220 | monique11@adventure-works.com | High School | Manual | Monique | Bac + 2 | Ouvrier | F | 1 | Vazquez | M | A | 0 | 2 | 4 | 1 (11) 500 555-0129 | Educación secundaria | Obrero | 4 | 20000 |
| 23963 | 46, rue des Pyrenees | AW00023963 | 1994-06-10 | 0-1 Miles | 2013-08-20 | 220 | gerald13@adventure-works.com | Partial High School | Manual | Gerald | Niveau bac | Ouvrier | M | 0 | Jimenez | M | E | 0 | 2 | 0 | 1 (11) 500 555-0133 | Educación secundaria (en curso) | Obrero | 0 | 10000 |
| 23969 | 7, rue des Vendangeurs | AW00023969 | 1982-04-06 | 0-1 Miles | 2013-07-14 | 220 | cole4@adventure-works.com | Bachelors | Manual | Cole | Bac + 4 | Ouvrier | M | 0 | Sanders | S | 0 | 0 | 0 | 1 (11) 500 555-0116 | Licenciatura | Obrero | 1 | 10000 | |
| 24012 | 17, rue de Varenne | AW00024012 | 1981-08-11 | 1-2 Miles | 2013-10-14 | 220 | james94@adventure-works.com | High School | Manual | James | Bac + 2 | Ouvrier | M | 0 | Lewis | S | F | 0 | 0 | 1 | 1 (11) 500 555-0182 | Educación secundaria | Obrero | 1 | 10000 |
| 24190 | 71, avenue Reille | AW00024190 | 1985-08-03 | 2-5 Miles | 2013-06-17 | 220 | austin22@adventure-works.com | Partial College | Manual | Austin | Baccalauréat | Ouvrier | M | 1 | Chen | S | V | 0 | 1 | 0 | 1 (11) 500 555-0119 | Estudios universitarios (en curso) | Obrero | 2 | 20000 |
| 24551 | 11, avenue du Président-Kennedy | AW00024551 | 1961-06-21 | 2-5 Miles | 2013-02-25 | 220 | molly5@adventure-works.com | Partial High School | Skilled Manual | Molly | Niveau bac | Technicien | F | 1 | Malhotra | M | 0 | 3 | 1 | 1 (11) 500 555-0161 | Educación secundaria (en curso) | Obrero especializado | 3 | 60000 | |
| 24570 | 285, rue de Varenne | AW00024570 | 1965-11-22 | 10+ Miles | 2013-11-24 | 220 | karen27@adventure-works.com | High School | Management | Karen | Bac + 2 | Direction | F | 1 | Guo | S | 0 | 3 | 1 | 1 (11) 500 555-0119 | Educación secundaria | Gestión | 4 | 90000 | |
| 24861 | 2, route de Marseille | AW00024861 | 1969-01-07 | 2-5 Miles | 2013-10-28 | 220 | evelyn4@adventure-works.com | Partial College | Professional | Evelyn | Baccalauréat | Cadre | F | 1 | Vance | M | C | 0 | 2 | 2 | 1 (11) 500 555-0184 | Estudios universitarios (en curso) | Profesional | 4 | 90000 |
| 15677 | 116, boulevard d´Albi | AW00015677 | 1985-05-13 | 0-1 Miles | 2012-09-27 | 220 | alyssa31@adventure-works.com | Graduate Degree | Clerical | Alyssa | Bac + 3 | Employé | F | 1 | Bradley | M | C | 0 | 0 | 0 | 1 (11) 500 555-0127 | Estudios de postgrado | Administrativo | 0 | 40000 |
| 16265 | 48, rue Montcalm | AW00016265 | 1993-03-17 | 2-5 Miles | 2013-10-02 | 220 | julie21@adventure-works.com | Bachelors | Clerical | Julie | Bac + 4 | Employé | F | 1 | Goel | M | 0 | 1 | 1 | 1 (11) 500 555-0151 | Licenciatura | Administrativo | 1 | 30000 | |
| 16273 | 309, route de Marseille | AW00016273 | 1986-08-13 | 0-1 Miles | 2012-10-26 | 220 | marie19@adventure-works.com | Bachelors | Skilled Manual | Marie | Bac + 4 | Technicien | F | 1 | Martinez | M | 0 | 2 | 1 | 1 (11) 500 555-0166 | Licenciatura | Obrero especializado | 1 | 30000 | |
| 16319 | 222, rue des Pyrenees | AW00016319 | 1992-08-23 | 2-5 Miles | 2013-03-24 | 220 | joy19@adventure-works.com | High School | Manual | Joy | Bac + 2 | Ouvrier | F | 1 | Ortega | S | A | 0 | 1 | 0 | 1 (11) 500 555-0173 | Educación secundaria | Obrero | 0 | 20000 |
| 16942 | 4, allée des Princes | AW00016942 | 1970-01-04 | 0-1 Miles | 2012-01-01 | 220 | kaitlyn69@adventure-works.com | Partial College | Manual | Kaitlyn | Baccalauréat | Ouvrier | F | 1 | Bennett | M | L | 0 | 1 | 0 | 1 (11) 500 555-0153 | Estudios universitarios (en curso) | Obrero | 2 | 10000 |
| 17739 | 8012, rue de Bas Marin | AW00017739 | 1983-02-09 | 0-1 Miles | 2012-07-22 | 220 | colin21@adventure-works.com | Partial College | Manual | Colin | Baccalauréat | Ouvrier | M | 0 | Cai | S | 0 | 0 | 1 | 1 (11) 500 555-0182 | Estudios universitarios (en curso) | Obrero | 1 | 20000 | |
| 17822 | 11, quai de l´ Iton | AW00017822 | 1979-01-15 | 0-1 Miles | 2013-09-02 | 220 | michelle18@adventure-works.com | Partial College | Clerical | Michelle | Baccalauréat | Employé | F | 1 | Cooper | S | L | 0 | 2 | 2 | 1 (11) 500 555-0129 | Estudios universitarios (en curso) | Administrativo | 2 | 30000 |
| 18128 | 6, route de Marseille | AW00018128 | 1973-09-08 | 2-5 Miles | 2013-04-15 | 220 | roberto17@adventure-works.com | High School | Professional | Roberto | Bac + 2 | Cadre | M | 0 | Suarez | M | D | 0 | 1 | 1 | 1 (11) 500 555-0131 | Educación secundaria | Profesional | 2 | 90000 |
| 19051 | 253, rue Lamarck | AW00019051 | 1970-02-19 | 10+ Miles | 2011-12-16 | 220 | taylor30@adventure-works.com | High School | Professional | Taylor | Bac + 2 | Cadre | F | 1 | Henderson | S | M | 0 | 1 | 2 | 1 (11) 500 555-0179 | Educación secundaria | Profesional | 4 | 90000 |
| 19069 | 811, rue Basse-du-Rocher | AW00019069 | 1971-10-11 | 5-10 Miles | 2012-01-10 | 220 | thomas84@adventure-works.com | High School | Management | Thomas | Bac + 2 | Direction | M | 1 | Hall | M | 0 | 3 | 1 | 1 (11) 500 555-0133 | Educación secundaria | Gestión | 4 | 90000 | |
| 19426 | 10, rue Lauriston | AW00019426 | 1986-03-16 | 0-1 Miles | 2012-10-22 | 220 | brian34@adventure-works.com | Bachelors | Clerical | Brian | Bac + 4 | Employé | M | 1 | Stewart | S | 0 | 0 | 0 | 1 (11) 500 555-0178 | Licenciatura | Administrativo | 0 | 30000 | |
| 19431 | 78, rue de l´Esplanade | AW00019431 | 1985-05-21 | 2-5 Miles | 2013-09-22 | 220 | bonnie5@adventure-works.com | Partial College | Manual | Bonnie | Baccalauréat | Ouvrier | F | 0 | She | S | 0 | 1 | 0 | 1 (11) 500 555-0162 | Estudios universitarios (en curso) | Obrero | 0 | 20000 | |
| 19444 | 22, avenue du Québec | AW00019444 | 1983-12-04 | 0-1 Miles | 2013-10-12 | 220 | kayla11@adventure-works.com | High School | Manual | Kayla | Bac + 2 | Ouvrier | F | 0 | Thomas | M | 0 | 1 | 2 | 1 (11) 500 555-0187 | Educación secundaria | Obrero | 2 | 10000 | |
| 19913 | 210, rue Maillard | AW00019913 | 1960-03-07 | 2-5 Miles | 2013-02-25 | 220 | jennifer14@adventure-works.com | High School | Professional | Jennifer | Bac + 2 | Cadre | F | 1 | Perez | M | M | 0 | 2 | 1 | 1 (11) 500 555-0187 | Educación secundaria | Profesional | 5 | 70000 |
| 20059 | 826, rue de Berri | AW00020059 | 1986-10-08 | 1-2 Miles | 2013-07-15 | 220 | madison25@adventure-works.com | High School | Manual | Madison | Bac + 2 | Ouvrier | F | 0 | Washington | M | 0 | 1 | 0 | 1 (11) 500 555-0184 | Educación secundaria | Obrero | 0 | 30000 | |
| 12464 | 646, place du Tertre | AW00012464 | 1983-07-17 | 0-1 Miles | 2011-07-23 | 220 | jared23@adventure-works.com | High School | Manual | Jared | Bac + 2 | Ouvrier | M | 1 | Cook | S | 0 | 1 | 3 | 1 (11) 500 555-0112 | Educación secundaria | Obrero | 3 | 10000 | |
| 12561 | 91, rue de Maubeuge | AW00012561 | 1957-04-20 | 0-1 Miles | 2011-09-25 | 220 | trisha2@adventure-works.com | Partial College | Manual | Trisha | Baccalauréat | Ouvrier | F | 1 | Lin | S | 0 | 1 | 0 | 1 (11) 500 555-0112 | Estudios universitarios (en curso) | Obrero | 2 | 10000 | |
| 12650 | 7024, rue Surcouf | AW00012650 | 1965-12-06 | 5-10 Miles | 2011-10-06 | 220 | aaron52@adventure-works.com | High School | Management | Aaron | Bac + 2 | Direction | M | 1 | Wright | M | L | 0 | 3 | 1 | 1 (11) 500 555-0180 | Educación secundaria | Gestión | 4 | 90000 |
| 12727 | 141, rue Jean Mermoz | AW00012727 | 1996-01-13 | 1-2 Miles | 2013-06-25 | 220 | amanda25@adventure-works.com | Partial High School | Manual | Amanda | Niveau bac | Ouvrier | F | 0 | Ross | S | E | 0 | 2 | 0 | 1 (11) 500 555-0184 | Educación secundaria (en curso) | Obrero | 0 | 20000 |
| 13595 | 20, rue des Rosiers | AW00013595 | 1967-03-04 | 10+ Miles | 2012-01-13 | 220 | cole23@adventure-works.com | Partial High School | Skilled Manual | Cole | Niveau bac | Technicien | M | 1 | Stewart | S | L | 0 | 2 | 2 | 1 (11) 500 555-0188 | Educación secundaria (en curso) | Obrero especializado | 5 | 70000 |
| 13811 | 810, rue des Rosiers | AW00013811 | 1979-01-18 | 0-1 Miles | 2012-02-23 | 220 | sandra8@adventure-works.com | Partial College | Clerical | Sandra | Baccalauréat | Employé | F | 1 | Chen | S | 0 | 2 | 2 | 1 (11) 500 555-0123 | Estudios universitarios (en curso) | Administrativo | 2 | 30000 | |
| 14176 | 99, avenue du Président-Kennedy | AW00014176 | 1961-12-08 | 2-5 Miles | 2013-06-10 | 220 | mindy22@adventure-works.com | Partial College | Professional | Mindy | Baccalauréat | Cadre | F | 0 | Rai | M | 0 | 2 | 0 | 1 (11) 500 555-0123 | Estudios universitarios (en curso) | Profesional | 5 | 80000 | |
| 14203 | 7346, avenue de l´Europe | AW00014203 | 1963-02-13 | 10+ Miles | 2012-03-01 | 220 | seth19@adventure-works.com | High School | Management | Seth | Bac + 2 | Direction | M | 1 | Rodriguez | S | 0 | 2 | 0 | 1 (11) 500 555-0145 | Educación secundaria | Gestión | 5 | 80000 | |
| 14930 | 47, impasse Ste-Madeleine | AW00014930 | 1984-04-02 | 0-1 Miles | 2012-05-05 | 220 | cindy10@adventure-works.com | Bachelors | Clerical | Cindy | Bac + 4 | Employé | F | 0 | Sara | S | M | 0 | 0 | 1 | 1 (11) 500 555-0120 | Licenciatura | Administrativo | 1 | 30000 |
| 14985 | 921, impasse Ste-Madeleine | AW00014985 | 1993-02-26 | 2-5 Miles | 2013-03-14 | 220 | jaclyn15@adventure-works.com | High School | Manual | Jaclyn | Bac + 2 | Ouvrier | F | 0 | Zhu | S | A | 0 | 1 | 0 | 1 (11) 500 555-0125 | Educación secundaria | Obrero | 0 | 20000 |
Generated 2024-05-02 16:46:46.877 UTC